Model Table BUSINESS OPP LINE

This model dimension represents the business opportunity lines and is based on the IFS Cloud dimension FACT_BUSINESS_OPP_LINE. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
Catalog Number	The sales part number.
Configurable	Indicates if the part is configurable.
Configurable Status	The status of the configuration created for the part.
Contract	Site
Contribution Object Reference 1	A reference to another object which was created by the opportunity line.
Contribution Object Reference 2	A reference to another object which was created by the opportunity line.
Contribution Object Reference 3	A reference to another object which was created by the opportunity line.
Contribution Object Reference 4	A reference to another object which was created by the opportunity line.
Contribution Object Type	The type of object referenced to the opportunity line.
Customer Part Number	The part number used by the customer for the opportunity line part.
Customer Part Unit Of Measure	The UoM used by the customer for the opportunity line part.
Description	The description of the opportunity line part.
Line Item	The opportunity line item
Line Number	The opportunity line number
Non Existing Part	An opportunity line part which has not been registered as a sales part.
Oppurtunity Number	The identity number of the business opportunity.
Original Part Number	Opportunity part number
Price Source	The origin of the part's price on the opportunity line.
Reason Note	A note which was added when the opportunity line was closed.
Revision Number	The opportunity line revision number.
Revision State	The status of the opportunity line revison.
Sales Part Type	Indicates if the opportunity line part is an inventory part or a non-inventory part.
Sales Unit Measure	UoM used for the opportunity line part.
State	The status of the oportunity line.

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
BUSINESS OPP LINE	FACT_BUSINESS_OPP_LINE_TM	FACT_BUSINESS_OPP_LINE_BI	FACT_BUSINESS_OPP_LINE	Data Mart